www.gusucode.com > VC++ ADO数据库操作入门的几个例子源码程序 > VC++ ADO数据库操作入门的几个例子源码程序/code/SQL语句中设置时段检索条件/SearchByTm/SearchByTmDlg.cpp
// SearchByTmDlg.cpp : implementation file // Download by http://www.NewXing.com #include "stdafx.h" #include "SearchByTm.h" #include "SearchByTmDlg.h" #include "atlbase.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // CAboutDlg dialog used for App About class CAboutDlg : public CDialog { public: CAboutDlg(); // Dialog Data //{{AFX_DATA(CAboutDlg) enum { IDD = IDD_ABOUTBOX }; //}}AFX_DATA // ClassWizard generated virtual function overrides //{{AFX_VIRTUAL(CAboutDlg) protected: virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support //}}AFX_VIRTUAL // Implementation protected: //{{AFX_MSG(CAboutDlg) //}}AFX_MSG DECLARE_MESSAGE_MAP() }; CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD) { //{{AFX_DATA_INIT(CAboutDlg) //}}AFX_DATA_INIT } void CAboutDlg::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CAboutDlg) //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CAboutDlg, CDialog) //{{AFX_MSG_MAP(CAboutDlg) // No message handlers //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CSearchByTmDlg dialog CSearchByTmDlg::CSearchByTmDlg(CWnd* pParent /*=NULL*/) : CDialog(CSearchByTmDlg::IDD, pParent) { //{{AFX_DATA_INIT(CSearchByTmDlg) m_tmEnd = 0; m_tmStart = 0; //}}AFX_DATA_INIT // Note that LoadIcon does not require a subsequent DestroyIcon in Win32 m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME); } void CSearchByTmDlg::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CSearchByTmDlg) DDX_Control(pDX, IDC_STUDENTS, m_StudentsLst); DDX_DateTimeCtrl(pDX, IDC_ENDTM, m_tmEnd); DDX_DateTimeCtrl(pDX, IDC_STARTTM, m_tmStart); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CSearchByTmDlg, CDialog) //{{AFX_MSG_MAP(CSearchByTmDlg) ON_WM_SYSCOMMAND() ON_WM_PAINT() ON_WM_QUERYDRAGICON() ON_BN_CLICKED(ID_SEARCH, OnSearch) ON_WM_DESTROY() //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CSearchByTmDlg message handlers BOOL CSearchByTmDlg::OnInitDialog() { CDialog::OnInitDialog(); // Add "About..." menu item to system menu. // IDM_ABOUTBOX must be in the system command range. ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX); ASSERT(IDM_ABOUTBOX < 0xF000); CMenu* pSysMenu = GetSystemMenu(FALSE); if (pSysMenu != NULL) { CString strAboutMenu; strAboutMenu.LoadString(IDS_ABOUTBOX); if (!strAboutMenu.IsEmpty()) { pSysMenu->AppendMenu(MF_SEPARATOR); pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu); } } // Set the icon for this dialog. The framework does this automatically // when the application's main window is not a dialog SetIcon(m_hIcon, TRUE); // Set big icon SetIcon(m_hIcon, FALSE); // Set small icon // TODO: Add extra initialization here //初始化环境 ::CoInitialize(NULL); //创建并打开数据库连接对象 _variant_t vFieldValue; CString strFieldValue; m_pCon.CreateInstance(__uuidof(Connection)); m_pCon->Open("students","","",NULL); //创建并打开记录集对象 m_pRs.CreateInstance(__uuidof(Recordset)); m_pRs->Open("select* from table1",m_pCon.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText); return TRUE; // return TRUE unless you set the focus to a control } void CSearchByTmDlg::OnSysCommand(UINT nID, LPARAM lParam) { if ((nID & 0xFFF0) == IDM_ABOUTBOX) { CAboutDlg dlgAbout; dlgAbout.DoModal(); } else { CDialog::OnSysCommand(nID, lParam); } } // If you add a minimize button to your dialog, you will need the code below // to draw the icon. For MFC applications using the document/view model, // this is automatically done for you by the framework. void CSearchByTmDlg::OnPaint() { if (IsIconic()) { CPaintDC dc(this); // device context for painting SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0); // Center icon in client rectangle int cxIcon = GetSystemMetrics(SM_CXICON); int cyIcon = GetSystemMetrics(SM_CYICON); CRect rect; GetClientRect(&rect); int x = (rect.Width() - cxIcon + 1) / 2; int y = (rect.Height() - cyIcon + 1) / 2; // Draw the icon dc.DrawIcon(x, y, m_hIcon); } else { CDialog::OnPaint(); } } // The system calls this to obtain the cursor to display while the user drags // the minimized window. HCURSOR CSearchByTmDlg::OnQueryDragIcon() { return (HCURSOR) m_hIcon; } void CSearchByTmDlg::OnSearch() { //情况列表框的数据 while(m_StudentsLst.GetCount()>0) { m_StudentsLst.DeleteString(0); } UpdateData(TRUE); //关闭上一次查询的记录集 m_pRs->Close(); //格式化时间 CString strBegin,strEnd; strBegin = m_tmStart.Format("%Y-%m-%d %H:%M:%S"); strEnd = m_tmEnd.Format("%Y-%m-%d %H:%M:%S"); //构造SQL检索语句 CString strSql; strSql.Format("select * from table1 where entertm >= CDate('%s') and entertm <= CDate('%s')",strBegin,strEnd); //检索 BSTR bsSql = strSql.AllocSysString(); m_pRs->Open((CComVariant)bsSql,m_pCon.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText); //将查询结果在列表框中显示出来 while(VARIANT_FALSE == m_pRs->EndOfFile) { _variant_t vFieldValue; CString strID,strName,strEnterTm; CString strItem; vFieldValue = m_pRs->GetCollect("id"); strID = (char*)_bstr_t(vFieldValue); vFieldValue.Clear(); vFieldValue = m_pRs->GetCollect("name"); strName = (char*)_bstr_t(vFieldValue); vFieldValue.Clear(); vFieldValue = m_pRs->GetCollect("entertm"); strEnterTm = (char*)_bstr_t(vFieldValue); vFieldValue.Clear(); strItem.Format("学号为%s的%s同学的入学时间是%s",strID,strName,strEnterTm); m_StudentsLst.AddString(strItem); m_pRs->MoveNext(); } } void CSearchByTmDlg::OnDestroy() { //关闭记录和连接 m_pRs->Close(); m_pCon->Close(); //释放环境 ::CoUninitialize(); CDialog::OnDestroy(); }